SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{9ab3c42a7cd9f483de87de3e25dc7dc90df6e7238bd0558386009a38cd54ac93}Cancelada{9ab3c42a7cd9f483de87de3e25dc7dc90df6e7238bd0558386009a38cd54ac93}' OR prCity = 'Cancelada' OR prZip = 'Cancelada' OR prStreet LIKE '{9ab3c42a7cd9f483de87de3e25dc7dc90df6e7238bd0558386009a38cd54ac93}Cancelada{9ab3c42a7cd9f483de87de3e25dc7dc90df6e7238bd0558386009a38cd54ac93}' OR prCountry = 'Cancelada') AND (prLocation LIKE '{9ab3c42a7cd9f483de87de3e25dc7dc90df6e7238bd0558386009a38cd54ac93}Spain{9ab3c42a7cd9f483de87de3e25dc7dc90df6e7238bd0558386009a38cd54ac93}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{9ab3c42a7cd9f483de87de3e25dc7dc90df6e7238bd0558386009a38cd54ac93}Spain{9ab3c42a7cd9f483de87de3e25dc7dc90df6e7238bd0558386009a38cd54ac93}' OR prCountry = 'Spain')